Michael J Moran/WRD/USGS/DOI 
05/14/2008 09:32 AM	To
Terri L Arnold/WRD/USGS/DOI@USGS
cc
Michael J Moran/WRD/USGS/DOI@USGS
bcc

Subject
PWSs in NE
	
	
	History:	
This message has been replied to.


Terri:

Here is the Excel file with all of the data -> pa.xlsx.  The first 
worksheet, titled Systems, contains the actual data with lat/longs for all 
systems.  The last worksheet is a summary of the systems by each principal 
aquifer.  I have highlighted the aquifers where we need to select a random 
subset of systems.

Just a little background for you -- I am trying to examine trends in MTBE 
in drinking water in the NE.  The data I have is for 6 States in the NE 
(CT, ME, NH, NJ, MD, RI) and is MTBE in finished drinking water.  The idea 
here is to examine a subset of one-well systems in principal aquifers for 
information on sources of MTBE, treatment, and other detailed ancillary 
data that will help us better understand trends, if any are present.

I forgot to mention to you on the phone that I would also like to stratify 
the selection process by RFG use area.  This is a binary in/out type code 
and is shown as the last column in the Systems worksheet.  Can you do 
something like this?

Lastly, I am attaching a zip file of pictures of the locations of the 
systems in relation to the principal aquifer and State.  I guess these are 
just gif files and not shape files.  I think I can make shape files if 
these would be helpful to you.  Just let me know.


Thanks for your help!


Mike



Michael Moran
National Water-Quality Assessment Program
U.S. Geological Survey
1608 Mountain View Road
Rapid City, SD 57702
(605) 394-3244